public class AdminUpdates {

    public static void editMemberDetails( String userName ,String memberNameUpdate, String memberPasswordUpdate, Long memberCardDetailsUpdate ){
        String responseMemberName = "username = '" + memberNameUpdate + "'" ;
        String responseMemberPassword = "userpassword = '" + memberPasswordUpdate + "'";
        String responseMemberCardDetails = "usercarddetails = " + memberCardDetailsUpdate;

        if( memberNameUpdate.equals( "" ) ){
            responseMemberName = "";
        }
        if( memberPasswordUpdate.equals( "" ) ){
            responseMemberPassword = "";
        }
        if( memberCardDetailsUpdate.equals( 0L ) ){
            responseMemberCardDetails = "";
        }

        try{
            System.out.println( "update userinfo set " + responseMemberName + responseMemberPassword + responseMemberCardDetails + " where username = '" + userName + "'" );
            DBConnection.addQuery( "update userinfo set " + responseMemberName + responseMemberPassword + responseMemberCardDetails + " where username = '" + userName + "'", ImageInJFrame.theConnection );
        }catch( Exception e ){
        }
    }

    public void editFilmDetails( String filmID, String updateDetails ){
        try{
            DBConnection.addQuery( "update films set details = " + updateDetails +" where filmID = " + filmID , ImageInJFrame.theConnection );
        }catch( Exception e ){
        }
    }

    public void editFilmReview( String filmID, String reviewID, String updateReview ){
        try{
            DBConnection.addQuery( "" , ImageInJFrame.theConnection );
        }catch( Exception e ){
        }
    }

    public void editNewsleter(){
        try{
            DBConnection.addQuery( "" , ImageInJFrame.theConnection );
        }catch( Exception e ){
        }
    }
}

